A vertical (column) lookup that searches the left column of the range indicated in the argument compare-range looking for the search value, lookup-value. If the search condition is met (as determined by the method argument), the column number of the found cell is offset by the amount specified in index. The function then returns the contents of that cell. If the search condition is not met, an error is returned.
Format: VLOOKUP (lookup-value, compare-range, index {,method})
Arguments:
ΓÇó lookup-value: A text or numeric expression.
ΓÇó compare-range: A cell range of one or more rows.
ΓÇó index: A numeric expression.
ΓÇó method: Optional. When the values in the first column are increasing from top to bottom, use 1 to locate the largest value which is less than or equal to the lookup value. When the values in the first column are decreasing from top to bottom, use -1 to locate the smallest value which is greater than or equal to lookup value. Use 0 to return the exact match to the lookup value. If the method is not specified, 1 will be used.
Note When specifying an ascending or descending range, be sure all the values are in order or you can get unexpected results.
